Today's Question:  What does your personal desk look like?        GIVE A SHOUT

SEARCH KEYWORD -- top 3

  Create trigger in MySQL

To create trigger in MySQL, the syntax is :CREATE [DEFINER = { user | CURRENT_USER }] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW trigger_bodyOne example is :DELIMITER %%DROP TRIGGER IF EXISTS delete_commentCREATE TRIGGER delete_comment AFTER DELETE ON file_generate_infoFOR EACH ROW BEGIN DELETE FROM article_comment WHERE article_id=OLD.article_id;END%%The whole create trigger statement should be complete statement but not many separate com...

   MySQL,Trigger,Dilimiter,phpMyAdmin     2011-04-20 15:35:30

  The rather petite Internet of 1995

As you may know if you’re a regular reader of this blog, sometimes we like to take a trip down memory lane. It’s time for another one of those trips, to the murky past of the Internet and the dawning World Wide Web of 1995.Let’s start first with the people who actually use the Internet. How many were there back then?Worldwide Internet users in 1995Today there are almost 2 billion Internet users worldwide. In 2000, there were 361 million worldwide. But go back even farther in...

   Internet,Web,1995,Netscape,Microsoft,Net     2011-05-27 12:50:46

  Select top 3 values from each group in a table with SQL

Yesterday, my friend Liu Bing asked me a question about how to select top 3 values for each person in a database table using SQL. I think this question is interesting and it deserves some thoughts. Here I record down how to solve this issue. Assume we have a table which has two columns, one column contains the names of some people and the other column contains some values related to each person. One person can have more than one value. Each value has a numeric type. The question is we want to se...

   SQL,Correlated query,top 3     2013-05-23 03:21:25

  Don't Overload #nil?

There’s a popular post on Hacker News about writing confident code by, among other things, overloading Object#nil? and returning “null objects” instead of nil itself.DO NOT DO THIS.In Ruby, all objects (except nil itself) coerce to the boolean value true. Your object will be nil and true at the same time. Bad things will happen. Your coworkers will cry. Sad people from around the world will ask bewildering questions on your mailing list.Here’s what happen...

   Ruby,#nil,Overload,Object     2011-11-10 10:50:22

  Substitute of Right Click Computer to Open Manage

I believe some of us may encounter some strange problems when we expect something normal to happen when we operate on our computer. On Windows 7, we may sometimes want to manage our service or applications by opening service manager.But somehow we may find that we cannot open it by clicking on Start->Right click on Computer->Manage.It may prompt some error message to tell us we cannot open the service manager. Then what to do? Here is a way to open it,goto Start->Run,then type "com...

   Computer Management,Win 7,compmgmt.msc,S     2011-03-31 01:09:44

  STOP WRITING GOOD CODE; START WRITING GOOD SOFTWARE

Good software trumps elaborate code. And unfortunately, you can’t usually have both. The real world has deadlines and ship dates. It’s a game of pick two:Ship on timeShip with elaborate codeShip with a fantastic productAlmost always, you should pick the first and the last when you’re building software applications for users (if you’re building API’s or open source libraries for other developers, then it’s a different story). Too often I have seen de...

   Good software,Standard,Good code,Deadline,Tradeoff     2011-11-20 06:56:06

  Android Tutorial: Creating and Using an SD Card in the Emulator

In a previous post, I mentioned how user-friendly Android is for developers. There’s extensive documentation and information on the architecture, the different components and best practices. However, the documentation has a few blind spots. Many of the tools have little documentation and no usage examples. The information is there, it’s just hidden behind a few layers of Android theory.So I’m going to try and document a few of the basic things that you’ll probabl...

   Android,Emulator,SDCard,Load,Create     2011-04-13 12:08:41

  10 Time-Management Tips That Work

Chances are good that, at some time in your life, you've taken a time-management class, read about it in books, and tried to use an electronic or paper-based day planner to organize, prioritize and schedule your day. "Why, with this knowledge and these gadgets," you may ask, "do I still feel like I can't get everything done I need to?"The answer is simple. Everything you ever learned about managing time is a complete waste of time because it doesn't work.Before you can even begin to manage time,...

   Time management,Tips,Work,Overhead     2011-10-10 05:24:01

  Create rounded corner buttons in photoshop using gradient

Hi People,I should rather call you photoshop lovers, right ? We are going to create a very simply yet eye catching but sober buttons in photoshop. They are simple light in weight and can be used the way you want. You can also add some glossy look if you wish to. But these days not many people like website with those glossy looks. Here is the final output which you will get after reading this tutorial.However many web-developers, webmasters, designers do not like to use images as buttons, but the...

   PhotoShop,Rounded button,Design,Gradient     2011-10-10 14:04:33

  VIM Plugins for C/C++ developers

Following up on my previous post on Essential Vim Plugins for Web Developers, I have decided to tell you about the awesomeness of the C / C++ plugin for Vim in this article.Now to get things going, let’s start by thinking what are the basic stuffs that you would be carrying out as a C / C++ developer? Include header files, some functions, loops, conditional statements and a main function. These are some repetitive boring tasks that you would rather have someone else do it for you. We...

   Plugin,Vim,C,C++,developer,Vim for C     2011-09-28 09:23:55

RECENT